Re: authentication problems

I typed "/usr/local/pgsql/bin/psql -h localhost" and
"/usr/local/pgsql/bin/psql -h 127.0.0.1" and they both returned the
same (odd) message:

psql: FATAL 1: database "postgres" does not exist in the system catalog


I'm connecting through JDBC using 7.1.3 on Darwin (Mac) OS 10.1.

Stefan Huber suggested that I tell JDBC to connect through the
"lo-network" device so that the 127.0.0.1 line in pg_hba.conf works.

thanks for thinking about this problem,


Russ




>Russ McBride <Russ@psyex.com> writes:
> > Thanks for the troubleshooting idea Nick.  I can ping localhost which
> > does show up as 127.0.0.1.  The error message I get is:
> > No entry in pg_hba.conf_file for 169.245.10.10 [or whatever ip
> > address I happen to be using at the time] for user: postgres
> > database: testdb
>
>Hmph.  How are you connecting exactly?  Do "psql -h localhost" and
>"psql -h 127.0.0.1" produce different results?  What do you have in
>/etc/hosts and /etc/resolv.conf?
>
>            regards, tom lane